<?php
defined('IN_MAIN') or exit('Invalid Access!');

function active_prod_refno_found($refno){
global $vars;
$db=$vars["db"];

return @mysql_num_rows(mysql_query("select * from $db->products where refno='$refno' and status='active'")) or false;
}
?>